Schedule CSV Generator

Upload your raw HotSchedules export to generate an hourly CSV.

Click to choose your schedule file

After generating, use the file in Step 2 as FOH/BOH hourly CSV.

Expected input: HotSchedules “Schedule Report” (Excel/HTML export). Hourly CSV

📘 How to Get the Correct File

Go to HotSchedules → Reporting → Dashboard → Schedules and Rosters → Schedule Report.
Select the week you want to review.
Change the Output option to EXCEL XP–2007.
Under Schedule Report Details, check Include Out Times.
Under Available Shifts, check Total Day.
Under Schedule Selection, choose the schedule(s) you want.

Important Notes:

FOH and BOH must be pulled separately if you want to analyze them separately in Step 2.
Ensure "Job Codes" are included if you want role-specific data.

📊 FOH Schedule File (CSV) Front of House - Format: Date,Time,Employee

🍳 BOH Schedule File (CSV) Back of House - Format: Date,Time,Employee

Avg Staff/Hour

12.2

Balanced coverage

Overall Productivity ($/LH)

$82

Average across staffed hours

Overall $/LH (Goal: $90.00)

$80

$-10 vs $90 goal

Total Labor Hours

1094 hrs

Overall scheduled hours

⏱️ Overtime Hours

0 hrs

No overtime detected

Overall Staff Coverage vs Sales Volume

Daypart:

💰 Estimated Daily Sales (Mon–Sat)

Mon

Tue

Wed

Thu

Fri

Sat

These values stay in place as you re-upload FOH/BOH schedules and are distributed across the day using the sales curve.

Hour
Upload a schedule to get started Use the FOH / BOH file inputs above, or click Load Demo Data

Staffing Levels:

Severely understaffed (2+ below suggested)

Slightly off (±1 from suggested)

On target (matches suggested)

Overstaffed (2+ above suggested)

Sales Volume:

Blue overlay = Sales intensity

Productivity (Goal $90/hr):

★ = Meeting goal ($90+)

◆ = Near goal ($80-89)

▼ = Below goal (<$80)

📈 Hourly Trends: Staffing vs Sales vs Productivity

💡 Optimization Insights

Below Productivity Target: Saturday 2 PM

20 staff scheduled achieving only $59/hour (goal: $90). Consider reducing by 6 staff members.

Exceeding Goal: Tuesday 12 PM

Excellent productivity at $132 per labor hour, exceeding the $90 goal by $42.

Exceeding Goal: Monday 12 PM

Excellent productivity at $122 per labor hour, exceeding the $90 goal by $32.

Exceeding Goal: Wednesday 12 PM

Excellent productivity at $122 per labor hour, exceeding the $90 goal by $32.

Exceeding Goal: Tuesday 11 AM

Excellent productivity at $119 per labor hour, exceeding the $90 goal by $29.

📊 Enhanced Staff Scheduling Counter

Schedule CSV Generator

📘 How to Get the Correct File

⏱️ Overtime Breakdown